﻿CREATE TABLE [dbo].[SIPaperAnswerItem]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [SqNo] INT NOT NULL, 
    [ItemName] NVARCHAR(50) NOT NULL, 
    [RecStatus] INT NOT NULL DEFAULT 0, 
    [RecCreateDt] DATETIME NOT NULL, 
    [RecUpdateDt] DATETIME NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自动编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'序号，用于显示排序',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'SqNo'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'ItemName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录状态: 0-使用中，1-未使用',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'RecStatus'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录创建时间 ',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'RecCreateDt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录更新时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'RecUpdateDt'